prepare($sql);
$stmt->execute([':staff_id' => $staff_id]);
$staff = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$staff) {
session_destroy();
header('Location: staff_login.php');
exit();
}
// Get class names
$class_ids = explode(',', $staff['classes']);
$class_placeholders = str_repeat('?,', count($class_ids) - 1) . '?';
$sql_classes = "SELECT classid FROM class WHERE sn IN ($class_placeholders)";
$stmt_classes = $DBcon->prepare($sql_classes);
$stmt_classes->execute($class_ids);
$assigned_classes = $stmt_classes->fetchAll(PDO::FETCH_COLUMN);
// Get subject names
$subject_ids = explode(',', $staff['subjects']);
$subject_placeholders = str_repeat('?,', count($subject_ids) - 1) . '?';
$sql_subjects = "SELECT subjectname FROM subjectss WHERE subject_id IN ($subject_placeholders)";
$stmt_subjects = $DBcon->prepare($sql_subjects);
$stmt_subjects->execute($subject_ids);
$assigned_subjects = $stmt_subjects->fetchAll(PDO::FETCH_COLUMN);
?>
Staff Dashboard - Excellence Academy